Model Table SHOP ORDER MATERIAL
Attributes
| Attribute | Description (where applicable) |
| SO Material Order No | Built as ORDER_NO + ' - ' + RELEASE_NO + ' - '
+ SEQUENCE_NO + ' - ' + LINE_ITEM_NO (MATERIAL_ORD_REL_SEQ_LINE). |
| SO Material Owner | Customer number owning the material. |
| SO Material Part Ownership | Ownership of material. Typically Company Owned, Customer
owned. |
| SO Material Status | Material line status for a record in the fact (STATE). |
| SO Material Supply Code | How is the material supplied? Invent Order, Project
delivery etc. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SHOP ORDER MATERIAL | FACT_SHOP_ORDER_MATERIAL_TM | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | Data Mart |